#include "SQLTable.h"
#include "../RealObject/Staff.h"
class CStaffTbl : public CSqlTable
{
public:
	CStaffTbl();
public:
	static CStaff* getStaff(CString sMSNV);

	static bool insertStaff(CStaff*pStaff);
	static bool updateStaff(CStaff*pStaff);
	static bool updatePermision(const CString& sCode,const int& nPermision);

	static bool updateCheckPoint(CString sCode, CString sTotal);
	static vector<CStaff*> getListStaff(int nPermission, CString sStore);

	static int getPermissonByCode(const CString& sCode);
	static vector<CStaff*> getListStaff();
	static int  getMaxCode();
};